package com.naiterui.ehp.bs.agent.repository;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.naiterui.common.repository.core.BaseJpaRepository;
import com.naiterui.ehp.bs.agent.entity.AsOrderCount;

/**
 * 经纪人统计-订单相关统计
 *
 * @author yangfuya
 * @since 2022/2/16
 */
@Repository
public interface IAsOrderCountRepository extends BaseJpaRepository<AsOrderCount, Long> {
    @Query(value = "select *  from as_order_count where generate_date =:generateDate  limit 1", nativeQuery = true)
    AsOrderCount getTotalByGenerateDate(@Param("generateDate") String generateDate);
}
